Entity Relationships - Profiling (M5$_PROFILE)

Related Tables

Table Name	Table Description	Primary Keys	Usually Joins From	Join Type	Joins On	Details
M5$_PROFILE	Profiles	PROFILEID				Stores a basic summary of each profile.
CONTRACT	Contracts	CONTRACTID	M5$_PROFILE	One to one	CONTRACTID	Stores details of each contract.
M5$_PROFILE_DIMENSION	Profile Dimensions	PROFILEID, DIMENSIONID	M5$_PROFILE	One to many	PROFILEID	Lists dimensions for each profile (i.e. groupings such as age group, SSA, year, quarter, etc).
M5$_PROFILE_DIMENSION_VALUES	Profile Dimension Values	VALUEID	M5$_PROFILE_DIMENSION	One to many	PROFILEID, DIMENSIONID	Lists values for each dimension (e.g. for age group there may be values of 16-18, 19-24 and 25+).
M5$_PROFILE_MEASUREMENT	Profile Measurements	MEASUREMENTID	M5$_PROFILE	One to many	PROFILEID	Stores profile measurement summaries.
M5$_PROFILE_MEASUREMENT_ITEM	Profile Measurement Items	MEASUREMENTITEMID	M5$_PROFILE_MEASUREMENT	One to many	MEASUREMENTID	Lists individual measurement lines, along with their actual volumes and values for the relevant dimension values.
M5$_PROFILE_MEASUREMENT_ITEM_DETAILS	Profile Measurement Item Details	DETAILID	M5$_PROFILE_MEASUREMENT_ITEM	One to many	MEASUREMENTITEMID	Stores details of measurement items (e.g. details of trainees which comprise the actual figures).
M5$_PROFILE_MEASUREMENT_ITEM_CLAIMLINK	Profile Measurement Item Claim-Link	MEASUREMENTID, CLAIMDETAILID	M5$_PROFILE_MEASUREMENT_ITEM	One to many	MEASUREMENTID	Links measurement items to claim lines.
CLAIMDETAILS	Claim Details	CLAIMDETAILID, CLAIMID, CONTRACTID	M5$_PROFILE_MEASUREMENT_ITEM_CLAIMLINK	One to one	CLAIMDETAILID	Stores details of claim lines.
M5$_PROFILE_FACTS	Profile Facts	PROFILEID, FACTID	M5$_PROFILE	One to many	PROFILEID	Lists the facts for each profile.